<%@ page language="java" import="com.demo.util.Conn,java.sql.ResultSet" pageEncoding="UTF-8"%>
<%
String job_id = request.getParameter("job_id");
String company_name = request.getParameter("company_name");
String Business_Nature = request.getParameter("Business_Nature");
String Job_Title = request.getParameter("Job_Title");
String Job_Nature = request.getParameter("Job_Nature");
String Job_Starting_Date = request.getParameter("Job_Starting_Date");
String Application_Deadline = request.getParameter("Application_Deadline");
String persion_num = request.getParameter("persion_num");
String Company_Introduction = request.getParameter("Company_Introduction");
String Job_Description = request.getParameter("Job_Description");
String Requirement = request.getParameter("Requirement");
String Additional_Information = request.getParameter("Additional_Information");
String Mailing_address = request.getParameter("Mailing_address");
String Website = request.getParameter("Website");
String Contact_Person = request.getParameter("Contact_Person");
String Position_held = request.getParameter("Position_held");
String Department = request.getParameter("Department");
String Email_address = request.getParameter("Email_address");
String Direct_Line = request.getParameter("Direct_Line");
String Facsimile = request.getParameter("Facsimile");

String sql = "update dbf_job_info SET company_name = " + "'" + company_name + "'"
			 + " , Business_Nature = " + "'" + Business_Nature + "'"
			 + " , Job_Title = " + "'" + Job_Title + "'"
			 + " , Job_Nature = " + "'" + Job_Nature + "'"
			 + " , Job_Starting_Date = " +"'" +  Job_Starting_Date + "'"
			 + " , Application_Deadline = " + "'" + Application_Deadline + "'"
			 + " , persion_num = " + "'" + persion_num + "'"
			 + " , Company_Introduction = " + "'" + Company_Introduction + "'"
			 + " , Job_Description = " + "'" + Job_Description + "'"
			 + " , Requirement = " + "'" + Requirement + "'"
			 + " , Additional_Information = " + "'" + Additional_Information + "'"
			 + " , Mailing_address = " + "'" + Mailing_address + "'"
			 + " , Website = " + "'" + Website + "'"
			 + " , Contact_Person = " + "'" + Contact_Person + "'"
			 + " , Position_held = " + "'" + Position_held + "'"
			 + " , Department = " + "'" + Department + "'"
			 + " , Email_address = " + "'" + Email_address + "'"
			 + " , Direct_Line = " + "'" + Direct_Line + "'"
			 + " , Facsimile = " + "'" + Facsimile + "'"
			 + " where job_id = " + job_id 
			 ;

Conn conn = new Conn();
boolean result = conn.execute(sql);
String redirect_address = "";
if(result){
	redirect_address = "jobManage.jsp?job_id=" + job_id;
	response.sendRedirect(redirect_address);
}
%>